SyStaffGroup

Logical Entity Name | SyStaffGroup
Default Table Name | SyStaffGroup
Physical Only | NO
Owner | dbo
Definition |
Note |

SyStaffGroup Columns

ColumnName | Domain | Datatype | NULL | Definition
Code |  | char(8) | NO |
Descrip |  | varchar(40) | NO |
active |  | bit | NO |
ModFlag |  | char(1) | NO |
SystemCode |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | YES |
ts |  | timestamp | NO |
SyStaffGroupID |  | int | NO |
RequiredForEnroll |  | bit | NO |
AdvisorModule |  | char(8) | YES |
OverrideLeadDup |  | bit | NO |
GroupType |  | char(4) | YES |
AllowDropLDAAttendChange |  | bit | NO |
CampusLinkAmbassadorUse |  | bit | NO |
PositivePayUse |  | bit | NO |
CrmSuppressFlag |  | bit | NO |

SyStaffGroup Primary and Unique Keys

Key Name | Key Type | Keys
SyStaffGroup_SyStaffGroupID_U_C_IDX | PrimaryKey | SyStaffGroupID

SyStaffGroup Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SyModule | Non-Identifying | Zero or One to Zero or More | FK_SyStaffGroup_AdvisorModule_SyModule_Code |  |  | AdvisorModule | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
cmActions | Non-Identifying | One To Zero or More | FK_cmActions_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
cmStaffGroupAccess | Non-Identifying | One To Zero or More | FK_cmStaffGroupAccess_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
FaCashPlanConfiguration | Non-Identifying | One To Zero or More | FK_FaCashPlanConfigurationPrintNotificationStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
FaCashPlanWorkflowAudit | Non-Identifying | One To Zero or More | FK_FaCashPlanWorkflowAuditCurrentAssignedStaffGroupId_SyStaffGroupStaffGroupId |  |  |  | NO | YES
FaCashPlanWorkflowAudit | Non-Identifying | One To Zero or More | FK_FaCashPlanWorkflowAuditPreviousAssignedStaffGroupId_SyStaffGroupStaffGroupId |  |  |  | NO | YES
FaPromNotePrintAssignment | Non-Identifying | One To Zero or More | FK_FaPromNotePrintAssignmentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
FaPromNotePrintAudit | Non-Identifying | One To Zero or More | FK_FaPromNotePrintAuditCurrentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
FaPromNotePrintAudit | Non-Identifying | One To Zero or More | FK_FaPromNotePrintAuditPreviousAssignedStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
FaStudentAidCashPlanAssignment | Non-Identifying | One To Zero or More | FK_FaStudentAidCashPlanAssignment_AssignedStaffGroupId_SyStaffGroup_StaffGroupId |  |  |  | NO | YES
SaACHConfig | Non-Identifying | One To Zero or More | FK_SaACHConfig_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SaBillCodeStaffGroupPost | Non-Identifying | One To Zero or More | FK_SaBillCodeStaffGroupPost_SyStaffGroupId_SyStaffGroup_SyStaffGroupId |  |  |  | NO | YES
SaDisbReceiptNotification | Non-Identifying | One To Zero or More | Fk_SaDisbReceiptNotification_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SaPWDAssignment | Non-Identifying | One To Zero or More | FK_SaPWDAssignmentAssignedStaffGroupID_SyStaffGroupSyStaffGroupID |  |  |  | NO | YES
SaPWDNotificationConfiguration | Non-Identifying | One To Zero or More | FK_SaPWDNotificationConfigurationNotificationStaffGroupID_SyStaffGroupSyStaffGroupID |  |  |  | NO | YES
SaPWDRoutingTemplate | Non-Identifying | One To Zero or More | FK_SaPWDRoutingTemplateAssignedStaffGroupID_SyStaffGroupSyStaffGroupID |  |  |  | NO | YES
SaRefundCalculationAssignment | Non-Identifying | One To Zero or More | FK_SaRefundCalculationAssignmentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
SaRefundCalculationRoutingTemplate | Non-Identifying | One To Zero or More | FK_SaRefundCalculationRoutingTemplateAssignedStaffGroupID_SyStaffGroupSyStaffGroupID |  |  |  | NO | YES
SaRefundCalculationWorkflowAudit | Non-Identifying | One To Zero or More | FK_SaRefundCalculationWorkflowAuditCurrentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
SaRefundCalculationWorkflowAudit | Non-Identifying | One To Zero or More | FK_SaRefundCalculationWorkflowAuditPreviousAssignedStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
SaReturnOfT4Assignment | Non-Identifying | One To Zero or More | FK_SaReturnOfT4AssignmentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
SaReturnOfT4PWDWorkflowAudit | Non-Identifying | One To Zero or More | FK_SaReturnOfT4PWDWorkflowAuditCurrentAssignedStaffGroupID_SyStaffGroupSyStaffGroupID |  |  |  | NO | YES
SaReturnOfT4PWDWorkflowAudit | Non-Identifying | One To Zero or More | FK_SaReturnOfT4PWDWorkflowAuditPreviousAssignedStaffGroupID_SyStaffGroupSyStaffGroupID |  |  |  | NO | YES
SaTransPendingChecks | Non-Identifying | One To Zero or More | Fk_SaTransPendingChecks_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SyAdvisorCampusDefaults | Identifying | One To Zero or More | FK_SyAdvisorCampusDefaults_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SYCTStaffGroup | Non-Identifying | One To Zero or More | FK_SYCTStaffGroup_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SYFSStaffGroup | Non-Identifying | One To Zero or More | FK_SYFSStaffGroup_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SySchoolStatusGridStaffGroup | Identifying | One To Zero or More | FK_SySchoolStatusGridStaffGroup_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SySecurity | Non-Identifying | One To Zero or More | FK_SySecurity_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SyServiceExceptionAssignment | Non-Identifying | One To Zero or More | FK_SyServiceExceptionAssign_AssignedStaffGroupId_SyStaffGroup_StaffGroupId |  |  |  | NO | YES
SyServiceExceptionAssignment | Non-Identifying | One To Zero or More | FK_SyServiceExceptionAssign_ReviewByStaffGroupId_SyStaffGroup_StaffGroupId |  |  |  | NO | YES
SyServiceExceptionAudit | Non-Identifying | One To Zero or More | FK_SyServiceExceptionAudit_CurrentAssignedStaffGroupId_SyStaffGroup_SyStaffGroupId |  |  |  | NO | YES
SyServiceExceptionAudit | Non-Identifying | One To Zero or More | FK_SyServiceExceptionAudit_CurrentReviewStaffGroupId_SyStaffGroup_SyStaffGroupId |  |  |  | NO | YES
SyServiceExceptionAudit | Non-Identifying | One To Zero or More | FK_SyServiceExceptionAudit_PreviousAssignedStaffGroupId_SyStaffGroup_SyStaffGroupId |  |  |  | NO | YES
SyServiceExceptionAudit | Non-Identifying | One To Zero or More | FK_SyServiceExceptionAudit_PreviousReviewStaffGroupId_SyStaffGroup_SyStaffGroupId |  |  |  | NO | YES
SyServiceExceptionCampusProperty | Non-Identifying | One To Zero or More | FK_SyServiceExceptionCampusProperty_ReviewByStaffGroupId_SyStaffGroup_StaffGroupId |  |  |  | NO | YES
SyServiceExceptionDocumentReview | Non-Identifying | One To Zero or More | FK_SyServiceExceptionDocumentReviewReviewSyStaffGroupId_SyStaffGroupSyStaffGroupID |  |  |  | NO | YES
SyServiceExceptionOverrideConfigurationTemplate | Non-Identifying | One To Zero or More | FK_SyServiceExceptionOverrideConfigurationTemplateAssignedStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
SyServiceExceptionSavedSearchAssignment | Non-Identifying | One To Zero or More | FK_SyServiceExceptionSavedSearchAssignmentAssignedStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
SyServiceExceptionTemplate | Non-Identifying | One To Zero or More | FK_SyServiceExceptionTemplateReviewByStaffGroupID_StaffGroupStaffGroupID |  |  |  | NO | YES
SyServiceNotificationTemplateAssignment | Non-Identifying | One To Zero or More | FK_SyServiceNotificationTemplateAssignmentNotifyStaffGroupId_SyStaffGroupSyStaffGroupId |  |  |  | NO | YES
SyServicePerformanceGoalsAssignment | Non-Identifying | One To Zero or More | FK_SyServicePerformanceGoalsAssignmentSyStaffGroupID_SyStaffGroupIDSyStaffGroupID |  |  |  | NO | YES
SyServiceStaffGroupDelegation | Non-Identifying | One To Zero or More | FK_SyServiceStaffGroupDelegation_StaffGroupId_SyStaffGroup_SyStaffGroupId |  |  |  | NO | YES
SyServiceStaffGroupHierarchy | Non-Identifying | One To Zero or More | FK_SyServiceStaffGroupHierarchy_StaffGroupId_SyStaffGroup_SyStaffGroupId |  |  |  | NO | YES
SyServiceStaffGroupHierarchy | Non-Identifying | One To Zero or More | FK_SyServiceStaffGroupHierarchy_SyStaffGroupId_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SyStaffByGroup | Non-Identifying | One To Zero or More | FK_SyStaffByGroup_syStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SyStaffGroupRefreshFreq | Non-Identifying | One To Zero or More | FK_SyStaffGroupRefreshFreq_SyStaffGroup |  |  |  | NO | YES
SyStaffGroupTemplate | Non-Identifying | One To Zero or More | FK_SyStaffGroupTemplate_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
SyStatusGridStaffGroup | Identifying | One To Zero or More | FK_SyStatusGridStaffGroup_SyStaffGroupID_SyStaffGroup_SyStaffGroupID |  |  |  | NO | YES
WorkspaceStaffGroup | Non-Identifying | One To Zero or More | FK_WorkSpaceStaffGroup_SyStaffGroupId_SyStaffGroup_SyStaffGroupId |  |  |  | NO | NO

SyStaffGroup Check Constraints

Check Constraint Name | CheckConstraint

SyStaffGroup Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SyStaffGroup Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StaffGroup | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyStaffGroup | NO |  |  |

SyStaffGroup Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Addresses_Affiliations
Logical | Employers
Logical | StudentEnrollment
Logical | Tasks
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyStaffGroup Data Movement Rules

Name | Type | Rule Text/Value